
Ansem Stelrach
Refugee Status
|
Posted - 2008.12.13 09:02:00 -
[1]
Originally by: Orexis Kirhal Any news on those of us that are getting the Filestream error? To repeat, I get the following error even though filestreaming has been enabled and I am the admin:
12/6/2008 1:05:35 PM Critical - Unable to enable the CLR on SQL server express. Inner Exception: FILESTREAM feature is not supported on user instances. Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install. Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at EveMarketMonitorApp.DatabaseClasses.Updater.InitDBs()
Ambo, I suspect I've found the reason why this is happening. SQL is attempting to attach the database files to the server. It seems that the application is attempting to attach the EVE DATA file first, and causing an exception because I believe that the attach information may have been hard coded to a file path in your personal Documents and Settings (I have a screenshot of the results when I attempted to attach the above file manually. Because the file path contains some personal information (your first name and last initial), I WILL NOT post the image here, but have eve-mailed you in-game to see if there's a good way of getting the screenshot to you.
When manually attaching the EMMA DATABASE.MDF file to the server, I get no problems. I hope this can shed some light to the situation.
|